﻿using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
using QLTH_DTO;

namespace QLTH_DATASSECC
{
   public class clsTonGiaoDA : ConnectionData.clsKetNoi
    {
       String _sql;
       public DataTable DanhSachTonGiao()
       {
           _sql = "SELECT MATG,TENTONGIAO FROM TONGIAO";
           return Load_DataTable(_sql);
       }

       public string Laymaytg(String _dk)
       {
           _sql = "SELECT MATG FROM TONGIAO WHERE TENTONGIAO = N'" + _dk + "'";
           return laymadk(_sql).ToString();
       }
    }
}
